Federation views as a basis for querying and updating database federations
نویسندگان
چکیده
This paper addresses the problem of how to query and update so-called database federations. A database federation provides for tight coupling of a collection of heterogeneous component databases into a global integrated system. This problem of querying and updating a database federation is tackled by describing a logical architecture and a general semantic framework for precise specification of such database federations, with the aim to provide a basis for implementing a federation by means of relational database views. Our approach to database federations is based on the UML/OCL data model, and aims at the integration of the underlying database schemas of the component legacy systems to a separate, newly defined integrated database schema. One of the central notions in database modelling and in constraint specifications is the notion of a database view, which closely corresponds to the notion of derived class in UML. We will employ OCL (version 2.0) and the notion of derived class as a means to treat (inter-)database constraints and database views in a federated context. Our approach to coupling component databases into a global, integrated system is based on mediation. The first objective of our paper is to demonstrate that our particular mediating system integrates component schemas without loss of constraint information. The second objective is to show that the concept of relational database view provides a sound basis for actual implementation of database federations, both for querying and updating purposes.
منابع مشابه
An ORM-Driven Implementation Framework for Database Federations
Database federations are employed more and more in situations involving virtual and integrated information on demand, e.g., real-time integration of two databases. Heterogeneity in hardware and software platforms, as well heterogeneity in underlying semantics of participating local databases, makes it a hard challenge to design a consistent and well-performing global database federation. The OR...
متن کاملIntegration of Inheritance Trees as Part of View Generation For Database Federations
Schema integration is the basis for successfully building a database federation. Current proposals directly integrate the diierent schemata using a semantical powerful data model, for example an extended ER model or an object-oriented model. We propose instead to use for integration a semantical poor model and build semantically rich representations as external views only. This approach enables...
متن کاملModeling Data Federations in ORM
Two major problems in constructing data federations (for example, data warehouses and database federations) concern achieving and maintaining consistency and a uniform representation of the data on the global level of the federation. The first step in creating uniform representations of data is known as data extraction, whereas data reconciliation is concerned with resolving data inconsistencie...
متن کاملFedra: Query Processing for SPARQL Federations with Divergence
Data replication and deployment of local SPARQL endpoints improve scalability and availability of public SPARQL endpoints, making the consumption of Linked Data a reality. This solution requires synchronization and specific query processing strategies to take advantage of replication. However, existing replication aware techniques in federations of SPARQL endpoints do not consider data dynamici...
متن کاملA Scalable Hybrid Architecture based SKOS Ontology for Resource Discovery in Grid
Resource discovery is an important service in a grid, since a grid enables the sharing and collaborating of a wide variety of resources which should be fully exploited. Based on Semantic Web technologies and the idea of resources clustering, this paper presents a comprehensive hybrid architecture based on SKOS lightweight ontology to organize and discover resources in an efficient and scalable ...
متن کامل